package com.sky.mapper.admin;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import java.time.LocalDate;
import java.time.LocalDateTime;
import java.util.List;

@Mapper
public interface ReportMapper {
    @Select("select order_time from orders where order_time between #{begin} and #{end}")
    List<LocalDate> turnoverStatistics(@Param("begin") LocalDate begin,@Param("end") LocalDate end);
    @Select("select amount from orders where status=6 and order_time between #{begin} and #{end}")
    List<BigDecimal> selectAmount(LocalDate begin, LocalDate end);
}
